/*
Navicat MySQL Data Transfer

Source Server         : sdfsf
Source Server Version : 50632
Source Host           : localhost:3306
Source Database       : bingo

Target Server Type    : MYSQL
Target Server Version : 50632
File Encoding         : 65001

Date: 2017-01-02 23:25:02
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for company
-- ----------------------------
DROP TABLE IF EXISTS `company`;
CREATE TABLE `company` (
  `CompanyNO` int(11) NOT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `ChargeName` varchar(255) DEFAULT NULL,
  `TypeNO` int(11) DEFAULT NULL,
  `JobTypeNO` int(11) DEFAULT NULL,
  `Sign` varchar(255) DEFAULT NULL,
  `SizeNO` int(11) DEFAULT NULL,
  `CompanyHref` varchar(255) DEFAULT NULL,
  `Address` varchar(255) DEFAULT NULL,
  `LogoPath` varchar(255) DEFAULT NULL,
  `CompanyLDNO` varchar(30) DEFAULT NULL,
  `Point` double(10,0) DEFAULT '0' COMMENT '计算等级',
  `Grade` varchar(100) DEFAULT NULL,
  `CreateTime` datetime DEFAULT NULL,
  `UpdateTime` datetime DEFAULT NULL,
  `Status` varchar(255) DEFAULT NULL,
  `Remark` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`CompanyNO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
